{\rtf1\ansi\ansicpg936\cocoartf1038\cocoasubrtf320
{\fonttbl\f0\fnil\fcharset134 STHeitiSC-Light;}
{\colortbl;\red255\green255\blue255;}
\vieww12000\viewh11400\viewkind0
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\ql\qnatural\pardirnatural

\f0\fs24 \cf0 1.  \'d0\'c2\'bd\'a8ArtEvent\'b1\'ed:\
DROP TABLE IF EXISTS [ArtEvent];\
CREATE TABLE [ArtEvent]\
(\
    [ID] integer primary key,           \
    [news_id] integer null default 0,\
    [title] varchar null default '',  \
    [thumb] varchar null default '',\
    [city] varchar null ,\
    [level] int null,\
    [starttime] varchar null,\
    [endtime] varchar null,\
    [address] varchar null,\
    [tel] varchar null,\
    [googleposi] varchar null,\
    [content] text null    \
   \
)\
\
2.\'c2\'b7\'d1\'dd\'d0\'c5\'cf\'a2\
DROP TABLE IF EXISTS [ArtRoadshowTour];\
CREATE TABLE [ArtRoadshowTour]\
(\
    [ID] integer primary key,           \
    [roadshow_id] integer null default 0,\
    [city] varchar null ,\
    [starttime] varchar null,\
    [endtime] varchar null,\
    [position] varchar null,\
    [description] text null    \
)\
\
3.\'d2\'d5\'ca\'f5\'d6\'ae\'c2\'c3\
DROP TABLE IF EXISTS [ArtTour];\
CREATE TABLE [ArtTour]\
(\
    [ID] integer primary key,           \
    [artTour_id] integer null default 0,\
    [city] varchar null ,\
    [starttime] varchar null,\
    [endtime] varchar null,\
    [position] varchar null,\
    [description] text null    \
)\
\
4.\'d2\'d5\'ca\'f5\'bf\'ce\'cc\'c3\
DROP TABLE IF EXISTS [ArtClass];\
CREATE TABLE [ArtClass]\
(\
    [ID] integer primary key,           \
    [ArtClass_id] integer null default 0,\
    [title] varchar null ,\
    [news_id] integer null ,    --\'bb\'ee\'b6\'afID\
    [description] text null ,\
    [content] text null,\
    [pubdate] varchar null   \
)\
\
5.\'be\'ad\'cf\'fa\'c9\'cc\
DROP TABLE IF EXISTS [Dealer];\
CREATE TABLE [Dealer]\
(\
    [ID] integer primary key,           \
    [dealer_id] integer null default 0,\
    [area] varchar null,\
    [dealername] varchar null,\
    [address] varchar null,\
    [tel] varchar null,\
    [emtel] varchar null,\
    [show] varchar null,\
    [maintain] varchar null \
)\
\
6.\'d2\'d5\'ca\'f5\'b5\'d8\'b1\'ea\
DROP TABLE IF EXISTS [ArtMark];\
CREATE TABLE [ArtMark]\
(\
    [ID] integer primary key,           \
    [artMark_id] integer null default 0,\
    [news_id] integer null,\
    [title] varchar null,\
    [thumb] varchar null,\
    [city] varchar null,\
    [marktype] varchar null,\
    [level] integer null,\
    [address] varchar null,\
    [tel] varchar null,\
    [googleposi] varchar null,\
    [content] text null,\
    [pubdate] varchar null  \
)\
\
\
\
\
create table artType\
\{\
	id int primary key not null,\
	name varchar not null\
\}\
\
\
create table artActivity\
\{\
	id int primary key not null,\
	activityId varchar,\
	title varchar,\
	thumb varchar,\
	city varchar,\
	address varchar,\
	tel varchar,\
	googleposi varchar,\
	pubdate varchar,\
	starttime varchar,\
	endtime varchar,\
	content text\
\}\
\
\
\
\
\
}